Hi @user13092632 , I maybe understand your question wrongly, but if you are asking how you can query your own subject areas built in your RPD and deployed in your OAC, then you can look at the good o…

You should look at the AGO function, that one will let you get the Amount for 2020 when on the 2021 year. And then, you can add a CASE WHEN to handle the case of the Amount existing already for that …

If EM works for what you need (you shouldn't be spending much time in there anyway), I wouldn't bother much… If you really want to try to get rid of that, you could try giving more memory t…

Hi Brett, welcome to the Oracle Analytics community and forum. The answer is yes and no … There is a public available instance used to display what OAC does, but I believe it's fully read-only (…

Hi, EM is slow as crazy, there is a simple config you can do to make the login a lot faster (it's about the discovery cache that you saw in the message). You can find the details on how to do th…